# -*- coding: UTF-8 -*-
"""
@Project ：lufei-learning-city 
@File    ：execl-读取sheet.py
@IDE     ：PyCharm 
@Author  ：于金龙@阿龙的代码在报错
@Date    ：2024/9/13 下午5:06 
"""
from openpyxl import load_workbook

# 打开execl文件

wb = load_workbook('二面简历统计.xlsx')

# 工作簿sheet的相关操作
print(wb.sheetnames)  # ['Sheet1']
# 2.选择sheet
sheet = wb['Sheet1']
cell = sheet.cell(1, 1)
print(cell.value)
# 3.选择sheet,基于索引位置
sheet = wb.worksheets[0]
cell = sheet.cell(1, 1)
print(cell.value)
